package com.hxzy.authentication.mapper;

import com.hxzy.authentication.domain.TsRealNameAuthentication;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author mingqian.Wu
 * @since 2023-06-23
 */

public interface TsRealNameAuthenticationMapper extends BaseMapper<TsRealNameAuthentication> {


    @Select("SELECT * FROM ts_real_name_authentication WHERE RIGHT(valid_period,10)=#{date}")
    List<TsRealNameAuthentication>selectAuthenticationByValidPeriod(String date);


}
